package com.example.db;

public interface TableConstant {
    String INIT_USER = "CREATE TABLE users (\n" +
            "    uid INTEGER PRIMARY KEY,\n" +
            "    uname VARCHAR(20),\n" +
            "    pwd VARCHAR(20),\n" +
            "    login_ip VARCHAR(20)\n" +
            ");\n";

    String INIT_FRIEND = "CREATE TABLE friends (\n" +
            "    id INTEGER PRIMARY KEY,\n" +
            "    uid INTEGER,\n" +
            "    fid INTEGER,\n" +
            "    FOREIGN KEY (uid) REFERENCES users(uid),\n" +
            "    FOREIGN KEY (fid) REFERENCES users(uid)\n" +
            ");\n";

    String INIT_MESSAGE = "CREATE TABLE friends (\n" +
            "    id INTEGER PRIMARY KEY,\n" +
            "    uid INTEGER,\n" +
            "    fid INTEGER,\n" +
            "    FOREIGN KEY (uid) REFERENCES users(uid),\n" +
            "    FOREIGN KEY (fid) REFERENCES users(uid)\n" +
            ");\n";
}
